create external table jms_ods.tab_province_category_config
(
  id           string comment'主键ID',
  province_id  string comment'省份编号',
  province     string comment'省份',
  city_id      string comment'城市编号',
  city_name    string comment'城市',
  category     string comment'类别：一类 二类 三类  四类 五类  六类'
) comment '省份类别配置表'
PARTITIONED BY (dt string COMMENT '时间分区(yyyy-MM-dd)')
stored as parquet
LOCATION '/dw/hive/jms_ods.db/external/tab_province_category_config'
TBLPROPERTIES ( 'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
